<?php 
	include"koneksi.php"; 
	
	if($_GET["aksi"]=="hapus")
	{
		$sql="DELETE FROM bis WHERE id_bis='$_GET[id_bis]'";
		mysql_query($sql);
	}
?>




<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Metamorphosis Design Free Css Templates</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="../styles.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
<!--
.style4 {
	color: #000000;
	font-family: Arial, Helvetica, sans-serif;
	font-size: 14px;
}
.style6 {color: #000000; font-size: 12px; }
-->
</style>
</head>
<body>
<div id="content">
<div id="back">
<!-- header begins -->
<div id="header">
<div id="menu">
<ul>
<li><a href="../index.php" title="">Home</a></li>
<li><a href="#" title="">Blog</a></li>
<li><a href="#" title="">Gallery</a></li>
<li><a href="#" title="">About</a></li>
<li><a href="#" title="">Contact</a></li>
</ul>
</div>
</div>
<!-- header ends -->
<!-- content begins -->
<div id="main">
<div id="logo">
<h1>&nbsp;</h1>
</div>
<div id="right">

		<table border="1" width="560" style="border:1px #666666 solid " align="center" bordercolor="#0099FF">
	
	<tr style="font-family:Arial, Helvetica, sans-serif; font-size:10px" bgcolor="#6666FF">
		<th width="65" height="38" align="center"><span class="style6">id_bis</span></th>
		<th width="55"><span class="style6">tipe_bis</span></th>
		<th width="65"><span class="style6">seat</span></th>
		<th width="70"><span class="style4">nopol</span></th>
		
        <th><span class="style6">Edit</span></th>
		<th><span class="style6">hapus</span></th>
	</tr>
	
	<?php
		$sql="SELECT * from bis";
		
		//"pemesanan.id_pesan,jadwal.tujuan,pemesanan.nama_pemesan,.pemesanan.kontak,pemesanan.alamat,
		//pemesanan.tanggal_pesan,pemesanan.jumlah FROM pemesanan,jadwal WHERE
	//pemesanan.id_jadwal= jadwal.id_jadwal"//
		
		$query=mysql_query($sql);
		while($row=mysql_fetch_array($query))
		{
			print"
			<tr style='font-family:Arial, Helvetica, sans-serif; font-size:15px'>
				<td align='center'>$row[id_bis]</td>
				<td align='center'>$row[tipe_bis]</td>
				<td align='center'>$row[seat]</td>
				<td align='center'>$row[nopol]</td>
				
		<td><a href=ubah_pemesanan_bis.php?id_bis=$row[id_bis]&&id_bis=$row[id_bis]>UBAH</a></td>
				<td align='center'><a href=?aksi=hapus&id_bis=$row[id_bis]>HAPUS</a></td>
			</tr>";
		}
	?>
</table>


</div>
<div id="left">
<h3>Categories</h3>
<div class="categories">
<ul>

<li><a href="../pemesanan/input_pemesanan.php">pemesanan</a></li>
<li><a href="jenis_bis.php">jenis_bis</a></li>
<li><a href="../ketersediaan/ketersediaan.php">ketersediaan</a></li>
<li><a href="#">tips bepergian</a></li>
<li><a href="#">info penumpang</a></li>


</ul>
</div>

<h3>Our Partners</h3>

<div class="partners">
<ul>

<li><a href="#">bajo express</a></li>
<li><a href="#">tour guide</a></li>


</ul>
</div>
</div>
<div style="clear: both;"></div>
<div id="mainbot"></div>

<!--content ends -->
<!--footer begins -->
</div>
<div class="bot_col"></div>
<div id="footer">
  <div id="footer2">
    <p>Copyright  2011.endang ayu ningsih (08560024)|chilman chakiki (08560404)| <a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="http://jigsaw.w3.org/css-validator/check/referer" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p>
    <p>Design by ayu and caki forDBT task</p>
  </div>
  <div style="clear: both"></div>
  <p>&nbsp;</p> 
</div>
<div style="clear: both"></div>
</div>

</div>
<!-- footer ends-->
</body>
</html>

